package org.com.coolfish.common.database.repository;

import java.util.List;

import org.com.coolfish.common.database.entity.KuyuPackage;
import org.com.coolfish.common.database.entity.KuyuPackageList;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface KuyuPackageListRepository extends JpaRepository<KuyuPackageList, Integer> {
	
	@Query("SELECT new KuyuPackageList(pl.name,pl.uid,pl.type,pl.old_id) FROM KuyuPackageList pl WHERE id = '32'")
	KuyuPackageList getPackageList(@Param("operatorLid")Integer operatorLid);
}
